GrapeCity.Xaml.CalcEngine
Evaluate(Object[]) Method


GrapeCity.CalcEngine.Functions Namespace > CalcSumIfsFunction Class > Evaluate Method : Evaluate(Object[]) Method

The args contains 3 - 255 items: sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ..

Sum_range is one or more cells to sum, including numbers or names, arrays, or references that contain numbers.

Criteria_range1, criteria_range2, ... are 1 to 126 ranges in which to evaluate the associated criteria.

Criteria1, criteria2, ... are 1 to 126 criteria in the form of a number, expression, cell reference, or text that define which cells will be added.

Adds the cells in a range that meet multiple criteria.
Syntax
'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object
'Usage
 
Dim instance As CalcSumIfsFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)
public override object Evaluate( 
   object[] args
)

Parameters

args

The args contains 3 - 255 items: sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ..

Sum_range is one or more cells to sum, including numbers or names, arrays, or references that contain numbers.

Criteria_range1, criteria_range2, ... are 1 to 126 ranges in which to evaluate the associated criteria.

Criteria1, criteria2, ... are 1 to 126 criteria in the form of a number, expression, cell reference, or text that define which cells will be added.

Return Value

A System.Double value that indicates the evaluate result.
See Also

Reference

CalcSumIfsFunction Class
CalcSumIfsFunction Members
Overload List